home *** CD-ROM | disk | FTP | other *** search
/ InterCD 2001 January / january_2001.iso / intercd / root / ^4Developers / VB / visbasdb / VBDB / VBDB Code / VB6 Code / Class 5 / QuickExample3.frm (.txt) < prev    next >
Encoding:
Visual Basic Form  |  1999-09-01  |  2.2 KB  |  73 lines
  1. VERSION 5.00
  2. Begin VB.Form Form1 
  3.    Caption         =   "Form1"
  4.    ClientHeight    =   2070
  5.    ClientLeft      =   60
  6.    ClientTop       =   345
  7.    ClientWidth     =   3900
  8.    LinkTopic       =   "Form1"
  9.    ScaleHeight     =   2070
  10.    ScaleWidth      =   3900
  11.    StartUpPosition =   3  'Windows Default
  12.    Begin VB.CommandButton Command2 
  13.       Caption         =   "&Next"
  14.       Height          =   495
  15.       Left            =   2280
  16.       TabIndex        =   3
  17.       Top             =   1440
  18.       Width           =   1215
  19.    End
  20.    Begin VB.CommandButton Command1 
  21.       Caption         =   "&Previous"
  22.       Height          =   495
  23.       Left            =   720
  24.       TabIndex        =   2
  25.       Top             =   1440
  26.       Width           =   1215
  27.    End
  28.    Begin VB.Label Label2 
  29.       Caption         =   "Label2"
  30.       Height          =   495
  31.       Left            =   240
  32.       TabIndex        =   1
  33.       Top             =   600
  34.       Width           =   1215
  35.    End
  36.    Begin VB.Label Label1 
  37.       Caption         =   "Label1"
  38.       DataField       =   "Title"
  39.       DataMember      =   "Command1"
  40.       DataSource      =   "DataEnvironment1"
  41.       Height          =   495
  42.       Left            =   240
  43.       TabIndex        =   0
  44.       Top             =   120
  45.       Width           =   3375
  46.    End
  47. Attribute VB_Name = "Form1"
  48. Attribute VB_GlobalNameSpace = False
  49. Attribute VB_Creatable = False
  50. Attribute VB_PredeclaredId = True
  51. Attribute VB_Exposed = False
  52. Option Explicit
  53. Private Sub Command1_Click()
  54. DataEnvironment1.rsCommand1.MovePrevious
  55. If DataEnvironment1.rsCommand1.BOF Then
  56.   DataEnvironment1.rsCommand1.MoveFirst
  57. End If
  58. End Sub
  59. Private Sub Command2_Click()
  60. DataEnvironment1.rsCommand1.MoveNext
  61. If DataEnvironment1.rsCommand1.EOF Then
  62.   DataEnvironment1.rsCommand1.MoveLast
  63. End If
  64. End Sub
  65. Private Sub Form_Activate()
  66. DataEnvironment1.rsCommand1.Close
  67. DataEnvironment1.rsCommand1.Open "SELECT * FROM Titles ORDER BY Title"
  68. Set Label1.DataSource = DataEnvironment1
  69. DataEnvironment1.rsCommand1.MoveLast
  70. DataEnvironment1.rsCommand1.MoveFirst
  71. Label2.Caption = DataEnvironment1.rsCommand1.RecordCount
  72. End Sub
  73.